package com.mp.approvalreq.dao;

import com.mp.approvalreq.entity.Comment;
import com.mp.approvalreq.entity.MessageRead;

import java.sql.SQLException;
import java.util.List;
import java.util.Map;

public interface CommentDao {
    /**
     * 获取评论列表
     *
     * @param requestId
     * @return
     * @throws SQLException
     */
    List<Comment> selectCommentList(Integer requestId) throws SQLException;

    /**
     * 添加评论
     *
     * @param comment
     * @return
     * @throws SQLException
     */
    int insertComment(Comment comment) throws SQLException;

    Comment selectCommentById(Integer id) throws SQLException;

    Comment selectLastComment(Integer requestId) throws SQLException;

    void UpdateCommentCancelStatus(Integer id) throws SQLException;
}
